﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace DAL
{
    public class Conexao
    {
        private static Conexao instance = new Conexao();

        public static Conexao Instance
        {
            get { return Conexao.instance; }    //instanciando a Conexão em um unico ponto
        }

        public SqlConnection getConnection()
        {
<<<<<<< .mine
            SqlConnection conn = new SqlConnection(@"Data Source=MIDORI-PC;Initial Catalog=facens;Integrated Security=True"); // string de conexão
=======
            SqlConnection conn = new SqlConnection(@"Data Source=RICARDO\SQLEXPRESS;Initial Catalog=rLaluna;Integrated Security=True"); // string de conexão
>>>>>>> .r58
                                        
                                        //trabalho
                                        //Data Source=beatriz;Initial Catalog=sga;Integrated Security=True

                                        //meu note
                                        //Data Source=MIDORI-PC;Initial Catalog=facens;Integrated Security=True                                        

            conn.Open();

            return conn;
        }        
    }
}
